Financial Management AFIN253
Tutorial 5, Week 6
Compulsory question that will be collected and marked.
Value the following business project to manufacture a new product.
Project Data | ||
Project life | 2 yrs | |
Initial investment in equipment | $6m | |
Depreciation of equipment per year | $3m | |
Expected sale price of equipment at end of project | $0.6m | |
Unit sales per year | 4m | |
Sale price per unit | $8 | |
Variable cost per unit | $5 | |
Fixed costs per year, paid at the end of each year | $1m | |
Interest expense per year | 0 | |
Tax rate | 30% | |
Weighted average cost of capital after tax per annum | 10% | |
Notes
- The firm's current assets and current liabilities are $3m and $2m respectively right now. This net working capital will not be used in this project, it will be used in other unrelated projects.
Due to the project, current assets (mostly inventory) will grow by $2m initially (at t = 0), and then by $0.2m at the end of the first year (t=1).
Current liabilities (mostly trade creditors) will increase by $0.1m at the end of the first year (t=1).
At the end of the project, the net working capital accumulated due to the project can be sold for the same price that it was bought. - The project cost $0.5m to research which was incurred one year ago.
Assumptions
- All cash flows occur at the start or end of the year as appropriate, not in the middle or throughout the year.
- All rates and cash flows are real. The inflation rate is 3% pa.
- All rates are given as effective annual rates.
- The business considering the project is run as a 'sole tradership' (run by an individual without a company) and is therefore eligible for a 50% capital gains tax discount when the equipment is sold, as permitted by the Australian Tax Office.
What is the expected net present value (NPV) of the project?
Since all cash flows are real and the and the discount rate is real, there is no need to convert rates or cash flows which is a relief.
About note 1. The firm's current assets and liabilities are irrelevant for evaluating our project since they will not change if we go ahead with the project or not. They are not incremental cash flows. But the increase in current assets and liabilities are incremental cash flows and will lead to a change in net working capital. Here is the general equation for calculating the change (or increase) in net working capital:
###\begin{aligned} \varDelta NWC &= NWC_\text{now} - NWC_\text{before} \\ &= (CA_\text{now} - CL_\text{now}) - (CA_\text{before} - CL_\text{before}) \\ &= \varDelta CA - \varDelta CL \\ \end{aligned}###
The increases in NWC at each time will be:
###\begin{aligned} \varDelta NWC_0 &= \varDelta CA - \varDelta CL \\ &= 2m - 0 \\ &= 2m \\ \varDelta NWC_\text{1} &= \varDelta CA - \varDelta CL \\ &= 0.2m - 0.1m \\ &= 0.1m \\ \varDelta NWC_\text{2} &= \varDelta CA - \varDelta CL \\ &= (-2m-0.2m) - (-0.1m) \\ &= -2.1m \\ \end{aligned}###
Note that ##\varDelta NWC_\text{2}## is negative because at the end of the project all of the working capital (which is probably mostly inventory) is sold. This is stated at the end of note 1. The lower inventory means current assets falls, which is a negative change.
About note 2. The research and development cost is a sunk cost so it should be ignored. It can not be recovered and it has to be paid whether we go ahead with the project or not, so it's irrelevant to our decision and evaluation.
When the equipment is sold at t=2 for $0.6m there will be negative capital expenditure (CapEx). Complicating matters is the capital gains tax (CGT) effect since the book carrying value (original cost less accumulated depreciation) of the equipment will be 0, so there will be a capital gain of $0.6m on which we have to pay CGT. Since the 50% CGT discount applies we can reduce the corporate tax rate so the CGT will be less. The capital expenditure will be:
###\begin{aligned} CapEx &= -(P_\text{mkt} - CGT) \\ &= -(P_\text{mkt} - (P_\text{mkt}-P_\text{book}).(1-\text{CGTDiscount}).t_c) \\ &=-(0.6m - (0.6m-0) \times(1-0.5) \times 0.3) \\ &=-0.51m \\ \end{aligned}###
Note that selling a capital asset is a negative capital expenditure (CapEx), that's why the figure is negative (-0.51m).
To find the Net Income (NI) which will be paid at the end of each year (t=1 and 2),
###\begin{aligned} NI &= (Rev-COGS-FC-Depr-IntExp).(1-t_c) \\ &= (Q(P-VC)-FC-Depr-IntExp).(1-t_c) \\ &= (4m(8-5)-1m-3m-0).(1-0.3) \\ &= 5.6m \end{aligned}###
To find the CFFA at each time period.
###\begin{aligned} CFFA_0 &= NI+Depr-CapEx - \varDelta NWC+IntExp \\ &= 0 +0 -6m - 2m +0 \\ &= -8m \\ CFFA_1 &= NI+Depr-CapEx - \varDelta NWC+IntExp \\ &= 5.6m +3m -0 - 0.1m +0 \\ &= 8.5m \\ CFFA_2 &= NI+Depr-CapEx - \varDelta NWC+IntExp \\ &= 5.6m +3m -(-0.51m) - (-2.1m) +0 \\ &= 11.21m \\ \end{aligned}###
The project value is the present value of the CFFA.
###\begin{aligned} V_\text{0, project} &= CFFA_0 + \frac{CFFA_1}{(1+r)^1} + \frac{CFFA_2}{(1+r)^2} \\ &= -8m + \frac{8.5m}{(1+0.1)^1} + \frac{11.21m}{(1+0.1)^2} \\ &= -8m + 7.72727273m + 9.26446281m \\ &= 8.99173553m \\ \end{aligned}###
Since the net present value is positive, the project should be accepted. The project will increase the value of the firm's assets by $8.99m.
Tutorial 5, Week 6
Homework questions.
Interest expense (IntExp) is an important part of a company's income statement (or 'profit and loss' or 'statement of financial performance').
How does an accountant calculate the annual interest expense of a fixed-coupon bond that has a liquid secondary market? Select the most correct answer:
Annual interest expense is equal to:
According to the 'effective interest method' which is the standard used by accountants when preparing financial reports, the interest expense for each debt contract equals the yield multiplied by its book value at the beginning of the period, with accrual adjustments if the debt matures during the year. Since the bond trades in a liquid market, the firm's accountants will 'mark to market' the bond price, so the bond's book value will be equal to its market value. Mathematically, the interest expense will be:
###IntExp_1 = r_{\text{D, 0}\rightarrow 1}.D_0###Some good articles on the effective interest method:
Here are the Net Income (NI) and Cash Flow From Assets (CFFA) equations:
###NI=(Rev-COGS-FC-Depr-IntExp).(1-t_c)###
###CFFA=NI+Depr-CapEx - \varDelta NWC+IntExp###
What is the formula for calculating annual interest expense (IntExp) which is used in the equations above?
Select one of the following answers. Note that D is the value of debt which is constant through time, and ##r_D## is the cost of debt.
Accountants use the 'effective interest method' to calculate interest expense which is the yield on the debt multiplied by its book value at the beginning of the period, with accrual adjustments if the debt matures during the year. Mathematically this is:
###IntExp_1 = r_D.D_0###Why is Capital Expenditure (CapEx) subtracted in the Cash Flow From Assets (CFFA) formula?
###CFFA=NI+Depr-CapEx - \Delta NWC+IntExp###
Capital expenditure (CapEx) is equal to 'net capital expenditure' which is the cash spent on (non-current) assets less the cash received from selling them. It is subtracted in the cash flow from assets (CFFA) equation to make up for how depreciation is added back. Since depreciation (Depr) is added back, no cost has been allocated to the assets bought such as land, buildings, factories and trucks, so it is subtracted in CFFA as CapEx.
The sum of the un-discounted Depr and CapEx amounts will cancel each other out, but there is a timing difference which is important. Depreciation allocates the asset cost over its life and this has nothing to do with cash flows, ignoring the time value of money. CapEx reflects when the money is actually spent, usually at the start when the asset is bought, taking the time value of money into account.
Which one of the following will increase the Cash Flow From Assets in this year for a tax-paying firm, all else remaining constant?
The net income (NI) equation and cash flow from assets (CFFA) equations are:
###NI=(Rev-COGS-FC-Depr-IntExp).(1-t_c)###
###CFFA=NI+Depr-CapEx - \varDelta NWC+IntExp###
Substituting NI into CFFA and then expanding and collecting like terms,
###\begin{aligned} CFFA &= (Rev-COGS-FC-Depr-IntExp).(1-t_c)+Depr-CapEx - \varDelta NWC+IntExp \\ &= (Rev-COGS-FC).(1-t_c)+\mathbf{Depr.t_c} -CapEx - \varDelta NWC+\mathbf{IntExp.t_c} \\ \end{aligned}###
The last bold term is called the interest tax shield (##IntExp.t_c##) which is the tax saving per year. Clearly, an increase in interest expense (IntExp) will lead to an increase in CFFA. This is because higher IntExp results in lower tax payments to the government since before-tax NI is lower. But IntExp does not affect CFFA since IntExp is a funding cost and has nothing to do with the firm's assets themselves, similarly for dividends.
It's quite surprising that higher interest expense actually leads to a CFFA increase and at the same time a NI decrease. It shows how CFFA (or better, the net present value of CFFA) can give quite a different picture of firm value compared with NI.
Note that the depreciation tax shield (##Depr.t_c##) is also shown in bold in the above equation. It's the tax saving per year from paying less tax to the government due to depreciation.
With regards to answers a and e, cash flows to creditors and equity holders equal CFFA, so if dividends or interest payments fall then CFFA must have fallen. Note that interest payments are not necessarily equal to interest expense, for example a zero coupon bond has no interest payments until maturity yet it has interest expense every year.
Cash Flow From Assets (CFFA) can be defined as:
Cash flow from assets (CFFA), also known as free cash flow to the firm (FCFF), is the cash generated from the firm's assets. It is the income component of the total dollar return from the assets, in the same way as shares, bonds and land have income returns called dividends, coupons and rent respectively. The idea is that the value of a project or business is the present value of its cash flow from assets in the same way that the value of a stock is the present value of its dividends.
Because a firm's assets (V) are owned by the debt (D) and equity (E) holders who fund it (V=D+E), the CFFA is indirectly owed to debt and equity holders. CFFA is the cash available to distribute to the debt and equity holders. CFFA is equal to the debt's coupon and principal payments less new debt raisings plus the equity's dividend and buy back payments less new equity raisings. The CFFA must equal the net payments to the debt and equity holders who fund the assets because if the CFFA is not paid out, the cash must have been kept by the business and thus increases net working capital, making CFFA zero. Here are some other examples which also hinge on the way the increase in net working capital (NWC) is subtracted from CFFA.
- If a firm pays a dividend to shareholders then the firm's cash will fall, causing a decrease in NWC which will increase CFFA. This increase is exactly equal to the dividend payment to shareholders.
- If a firm raises equity in an initial public offering (IPO), then the cash raised will increase current assets (cash) and will be subtracted in the CFFA equation as an increase in net working capital. The cash payment by the shareholders to the company for the shares in the IPO is a negative cash flow from the company to the shareholders, and this is equal to the negative CFFA due to the large increase in NWC.
- A firm earns positive net income and generates excess cash but no debt or equity is raised or paid out. It seems like there is a positive CFFA and it is not equal to the zero payments to debt or equity holders. But in fact, if no cash flows are paid to or received from debt or equity holders, then the excess cash will just sit in the bank account, increasing net working capital, and causing CFFA to be zero, which is equal to the zero payments to debt and equity holders. So actually CFFA was not positive, it was zero. We just overlooked that the excess cash increases NWC.
Summarizing with an equation,
###\begin{aligned} CFFA &= (\text{net payments to debt holders}) + (\text{net payments to equity holders}) \\ &= (\text{payments to debt holders}) - (\text{receipts from debt holders}) + (\text{payments to equity holders}) - (\text{receipts from equity holders}) \\ &= (\text{coupon and principal payments}) - (\text{new debt raisings}) + (\text{dividend and buyback payments}) - (\text{new equity raisings}) \\ \end{aligned} ###
A firm has forecast its Cash Flow From Assets (CFFA) for this year and management is worried that it is too low. Which one of the following actions will lead to a higher CFFA for this year (t=0 to 1)? Only consider cash flows this year. Do not consider cash flows after one year, or the change in the NPV of the firm. Consider each action in isolation.
Buying less capital assets (non-current assets) such as land, buildings and trucks will decrease CapEx and increase CFFA.
###CFFA=NI+Depr-CapEx - \varDelta NWC+IntExp###There will be less depreciation and therefore a lower depreciation tax shield, causing a decrease in CFFA, but this is likely to be a small effect compared to the fall in CapEx.
###\begin{aligned} CFFA &= NI+Depr-CapEx - \varDelta NWC+IntExp \\ &= (Rev-COGS-FC-Depr-IntExp).(1-t_c)+Depr-CapEx - \varDelta NWC+IntExp \\ &= (Rev-COGS-FC).(1-t_c)+\mathbf{Depr.t_c} -CapEx - \varDelta NWC+IntExp.t_c \\ \end{aligned}###
A zero coupon bond that matures in 6 months has a face value of $1,000.
The firm that issued this bond is trying to forecast its income statement for the year. It needs to calculate the interest expense of the bond this year.
The bond is highly illiquid and hasn't traded on the market. But the finance department have assessed the bond's fair value to be $950 and this is its book value right now at the start of the year.
Assume that:
- the firm uses the 'effective interest method' to calculate interest expense.
- the market value of the bond is the same as the book value.
- the firm is only interested in this bond's interest expense. Do not include the interest expense for a new bond issued to refinance the current one, as would normally happen.
What will be the interest expense of the bond this year for the purpose of forecasting the income statement?
Tax accountants apply the 'effective interest method' as below.
First find the effective annual yield of the zero coupon bond (##r_\text{eff, yearly}##). Note that the price is simply the present value of the principal since there are no coupons:
###\begin{aligned} P_0 &= \frac{F_T}{(1 + r_{\text{eff yrly, 0}\rightarrow T})^{T_\text{years}}} \\ &= \frac{F_\text{0.5yr}}{(1 + r_{\text{eff yrly, 0}\rightarrow 0.5yr})^{0.5}} \\ 950 &= \frac{1,000}{(1 + r_{\text{eff yrly, 0}\rightarrow 0.5yr})^{0.5}} \\ \end{aligned} ###
###\begin{aligned} r_{\text{eff yrly, 0}\rightarrow 0.5yr} &= \left( \frac{1,000}{950} \right)^{1 / 0.5} -1 \\ &=0.108033241 \\ \end{aligned} ###
Multiply the book value of the bond at the start of the period by the yield just calculated to find the annual interest expense. But since this bond matures in 6 months, only half of the interest expense will be 'accrued'. Note that tax accountants use 'accrual methods' to allocate the interest expense. They don't find present or future values, they would just multiply the annual amount by half to get 6 months' worth of interest expense:
###\begin{aligned} \text{IntExp}_\text{6mths} &= \text{IntExp}_\text{annual}.\frac{1}{2} \\ &= D_\text{book value}.r_\text{eff, yearly}.\frac{1}{2} \\ &= 950 \times 0.108033241 \times \frac{1}{2} \\ &=102.6315789 \times \frac{1}{2} \\ &= 51.31578947 \\ \end{aligned} ###
Note that this version of interest expense is only used for accounting purposes. It is not the true 'cost of debt' that a finance person would calculate. But it is important to know how accountants find this amount since it is relevant for the calculation of tax which is a cash flow, not an imaginary accrual item like interest expense or depreciation.
Commentary
The 'finance version' of the true cost of debt in dollar terms in 6 months when the bond matures is simply the increase in the value of the debt liability. Since it's a zero-coupon bond there's no coupons and only the principal to pay, and in 6 months the bond matures and has a value of the principal, so the dollar cost of debt in 6 months is $50 (=1,000 - 950).
Mathematically, this is the future value of the bond price and coupons less then current bond price. This is also equal to the total return of the bond multiplied by the current price. Remembering that the coupon (##c_\text{0.5yrs}##) is zero:
###\begin{aligned} V_\text{0.5yrs, cost of debt} &= p_0.r_{0 \rightarrow \text{0.5yrs}} \\ &= p_0.\frac{(p_\text{0.5yrs} - p_0 + c_\text{0.5yrs})}{p_0} \\ &= p_\text{0.5yrs} - p_0 + c_\text{0.5yrs} \\ &= 1,000 - 950 + 0 \\ &= 50 \\ \end{aligned} ###
To make it a value in one year which is when the business prepares its accounts, find the future value in another 6 months. Assume that the yield curve is flat, so the forward rate applying from 6 months to one year is the same as the spot 6 month rate which is the total return of the bond, so : ### r_{\text{eff yrly, 0}\rightarrow 0.5yr} = r_{\text{eff yrly, 0.5yr}\rightarrow 1yr} = 0.108033241 ######\begin{aligned} V_\text{1yr, cost of debt} &= V_\text{0.5yrs, cost of debt}(1+r_{\text{eff yrly, 0.5yr}\rightarrow 1yr})^{0.5} \\ &= 50(1+0.108033241)^{0.5} \\ &= 52.63157895 \\ \end{aligned} ###
The difference between the accounting and finance versions of the cost of debt in this example is quite small and is all due to accrual differences stemming from how the bond matures half way through the year. If the bond matured in more than one year then both the accounting and finance versions would be the same.
Find World Bar's Cash Flow From Assets (CFFA), also known as Free Cash Flow to the Firm (FCFF), over the year ending 30th June 2013.
World Bar | ||
Income Statement for | ||
year ending 30th June 2013 | ||
$m | ||
Sales | 300 | |
COGS | 150 | |
Operating expense | 50 | |
Depreciation | 40 | |
Interest expense | 10 | |
Taxable income | 50 | |
Tax at 30% | 15 | |
Net income | 35 | |
World Bar | ||
Balance Sheet | ||
as at 30th June | 2013 | 2012 |
$m | $m | |
Assets | ||
Current assets | 200 | 230 |
PPE | ||
Cost | 400 | 400 |
Accumul. depr. | 75 | 35 |
Carrying amount | 325 | 365 |
Total assets | 525 | 595 |
Liabilities | ||
Current liabilities | 150 | 205 |
Non-current liabilities | 235 | 250 |
Owners' equity | ||
Retained earnings | 100 | 100 |
Contributed equity | 40 | 40 |
Total L and OE | 525 | 595 |
Note: all figures above and below are given in millions of dollars ($m).
Using the cash flow from assets equation,
### CFFA = NI + Depr - CapEx - \Delta NWC + IntExp ###Capital expenditure (CapEx) can be calculated as the change in Net Fixed Assets (NFA) plus depreciation. Note that NFA is the same thing as the carrying amount of property, plant and equipment (PPE).
###\begin{aligned} CapEx &= NFA_\text{now} - NFA_\text{before} + Depr \\ &= 325 - 365 + 40 \\ &= 0 \\ \end{aligned}###
Since CapEx is zero, the firm either didn't spend or sell any of its capital assets, or it sold the exact same amount of assets that it bought or upgraded.
Another way to calculate CapEx is to look at the difference in the gross or undepreciated cost:
###\begin{aligned} CapEx &= GFA_\text{now} - GFA_\text{before} \\ &= 400 - 400 \\ &= 0 \\ \end{aligned}###
To find the change in net working capital (##\Delta NWC##), take the difference between the NWC now and before:
###\begin{aligned} \Delta NWC &= CA_\text{now} - CL_\text{now} - (CA_\text{before} - CL_\text{before}) \\ &= 200-150 - (230-205) \\ &= 50 - (25) \\ &= 25 \\ \end{aligned}###
Now just substitute the values:
###\begin{aligned} CFFA &= NI + Depr - CapEx - \Delta NWC + IntExp \\ &= 35 + 40- 0 - 25 + 10 \\ &= 60 \\ \end{aligned}###
Find Trademark Corporation's Cash Flow From Assets (CFFA), also known as Free Cash Flow to the Firm (FCFF), over the year ending 30th June 2013.
Trademark Corp | ||
Income Statement for | ||
year ending 30th June 2013 | ||
$m | ||
Sales | 100 | |
COGS | 25 | |
Operating expense | 5 | |
Depreciation | 20 | |
Interest expense | 20 | |
Income before tax | 30 | |
Tax at 30% | 9 | |
Net income | 21 | |
Trademark Corp | ||
Balance Sheet | ||
as at 30th June | 2013 | 2012 |
$m | $m | |
Assets | ||
Current assets | 120 | 80 |
PPE | ||
Cost | 150 | 140 |
Accumul. depr. | 60 | 40 |
Carrying amount | 90 | 100 |
Total assets | 210 | 180 |
Liabilities | ||
Current liabilities | 75 | 65 |
Non-current liabilities | 75 | 55 |
Owners' equity | ||
Retained earnings | 10 | 10 |
Contributed equity | 50 | 50 |
Total L and OE | 210 | 180 |
Note: all figures are given in millions of dollars ($m).
Using the cash flow from assets equation,
### CFFA = NI + Depr - CapEx - \Delta NWC + IntExp ###Capital expenditure (CapEx) can be calculated as the change in Net Fixed Assets (NFA) plus depreciation. Note that NFA is the same thing as the carrying amount of property, plant and equipment (PPE).
###\begin{aligned} CapEx &= NFA_\text{now} - NFA_\text{before} + Depr \\ &= 90 - 100+ 20 \\ &= 10 \\ \end{aligned}###
Since CapEx is positive, the firm must have spent more on capital assets than it sold.
Another way to calculate CapEx is to look at the difference in the gross or undepreciated cost:
###\begin{aligned} CapEx &= GFA_\text{now} - GFA_\text{before} \\ &= 150- 140 \\ &= 10 \\ \end{aligned}###
To find the change in net working capital (##\Delta NWC##), take the difference between the NWC now and before:
###\begin{aligned} \Delta NWC &= CA_\text{now} - CL_\text{now} - (CA_\text{before} - CL_\text{before}) \\ &= 120-75 - (80-65) \\ &= 45 - (15) \\ &= 30 \\ \end{aligned}###
Now just substitute the values:
###\begin{aligned} CFFA &= NI + Depr - CapEx - \Delta NWC + IntExp \\ &= 21+ 20 -10 - 30 + 20 \\ &= 21 \\ \end{aligned}###
Find UniBar Corp's Cash Flow From Assets (CFFA), also known as Free Cash Flow to the Firm (FCFF), over the year ending 30th June 2013.
UniBar Corp | ||
Income Statement for | ||
year ending 30th June 2013 | ||
$m | ||
Sales | 80 | |
COGS | 40 | |
Operating expense | 15 | |
Depreciation | 10 | |
Interest expense | 5 | |
Income before tax | 10 | |
Tax at 30% | 3 | |
Net income | 7 | |
UniBar Corp | ||
Balance Sheet | ||
as at 30th June | 2013 | 2012 |
$m | $m | |
Assets | ||
Current assets | 120 | 90 |
PPE | ||
Cost | 360 | 320 |
Accumul. depr. | 40 | 30 |
Carrying amount | 320 | 290 |
Total assets | 440 | 380 |
Liabilities | ||
Current liabilities | 110 | 60 |
Non-current liabilities | 190 | 180 |
Owners' equity | ||
Retained earnings | 95 | 95 |
Contributed equity | 45 | 45 |
Total L and OE | 440 | 380 |
Note: all figures are given in millions of dollars ($m).
Using the cash flow from assets equation,
### CFFA = NI + Depr - CapEx - \Delta NWC + IntExp ###Capital expenditure (CapEx) can be calculated as the change in Net Fixed Assets (NFA) plus depreciation. Note that NFA is the same thing as the carrying amount of property, plant and equipment (PPE).
###\begin{aligned} CapEx &= NFA_\text{now} - NFA_\text{before} + Depr \\ &= 320- 290+ 10 \\ &= 40 \\ \end{aligned}###
Since CapEx is positive, the firm must have spent more on capital assets than it sold.
Another way to calculate CapEx is to look at the difference in the gross or undepreciated cost:
###\begin{aligned} CapEx &= GFA_\text{now} - GFA_\text{before} \\ &= 360- 320\\ &= 40 \\ \end{aligned}###
To find the change in net working capital (##\Delta NWC##), take the difference between the NWC now and before:
###\begin{aligned} \Delta NWC &= CA_\text{now} - CL_\text{now} - (CA_\text{before} - CL_\text{before}) \\ &= 120-110 - (90-60) \\ &= 10 - (30) \\ &= -20 \\ \end{aligned}###
Now just substitute the values:
###\begin{aligned} CFFA &= NI + Depr - CapEx - \Delta NWC + IntExp \\ &= 7+ 10 -40 - (-20) + 5 \\ &= 2 \\ \end{aligned}###